package com.dfy.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dfy.entity.SpotDetail;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SpotDetailMapper extends BaseMapper<SpotDetail> {
    @Select("SELECT * FROM spot_details WHERE spot_id = #{spotId}")
    SpotDetail selectBySpotId(Long spotId);

    @Delete("DELETE FROM spot_details WHERE spot_id = #{spotId}")
    int deleteBySpotId(Long spotId);
} 